/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : localhost:3306
 Source Schema         : initialize_db

 Target Server Type    : MySQL
 Target Server Version : 50723
 File Encoding         : 65001

 Date: 08/01/2020 22:49:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `_id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, 'ROLE_ADMIN');
INSERT INTO `role` VALUES (2, 'ROLE_USER');
COMMIT;

-- ----------------------------
-- Table structure for sjnum
-- ----------------------------
DROP TABLE IF EXISTS `sjnum`;
CREATE TABLE `sjnum` (
  `_id` varchar(11) COLLATE utf8_bin NOT NULL,
  `sjnum` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of sjnum
-- ----------------------------
BEGIN;
INSERT INTO `sjnum` VALUES ('123123', '123');
INSERT INTO `sjnum` VALUES ('15385311505', '9671');
INSERT INTO `sjnum` VALUES ('17682105180', '1780');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_id` varchar(11) COLLATE utf8_bin NOT NULL,
  `u_name` varchar(255) COLLATE utf8_bin DEFAULT '蒙面侠',
  `u_login` varchar(255) COLLATE utf8_bin NOT NULL,
  `u_psd` varchar(255) COLLATE utf8_bin NOT NULL,
  `u_jnyipsd` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '123456',
  `u_liveness` varchar(255) COLLATE utf8_bin DEFAULT '0.01',
  `u_uplisstrut` int(11) NOT NULL DEFAULT '0',
  `u_phone` varchar(255) COLLATE utf8_bin NOT NULL,
  `u_alipay` varchar(255) COLLATE utf8_bin NOT NULL,
  `superior_id` varchar(11) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `u_struts` int(255) NOT NULL DEFAULT '0',
  `u_settime` datetime NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (2, '15385311505', '北桥', '15385311505', '22222222', '111111', '0.01', 0, '15385311505', '15385311505', '0', 1, '2019-10-22 04:44:54', 1);
INSERT INTO `user` VALUES (4, '17682105180', '简新远', '123', '$2a$10$mH.T50.x9gn39o9h8FZfwu2gGqEVBCpLTrxd8nSipXrv3ibMxCeSO', '555555', '0.01', 0, '17682105180', '17682105180', '15385311505', 0, '2019-10-22 04:45:41', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
